package com.zy.teacherSide.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zy.teacherSide.entity.TeacherEnclosure;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

/**
 * @author 29787
 */
@Mapper
@Component
public interface TeacherEnclosureDao extends BaseMapper<TeacherEnclosure> {

    /**
     * 根据教师id和附件id查询附件信息
     * @param teacherId
     * @param enclosureId
     * @return TeacherEnclosure
     */
    @Select("select * from hms_teacher_enclosure where teacher_id=#{teacherId} and enclosure_id=#{enclosureId}")
    TeacherEnclosure getTeacherEnclosureById(Integer teacherId,Integer enclosureId);
}
